Dataset statistics
| Number of variables | 12 |
|---|---|
| Number of observations | 950 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 89.2 KiB |
| Average record size in memory | 96.1 B |
Variable types
| Numeric | 12 |
|---|
amperestunden is highly correlated with zyklus_ and 5 other fields | High correlation |
zyklus_ is highly correlated with amperestunden and 4 other fields | High correlation |
temperature_amax is highly correlated with temperature_amin and 3 other fields | High correlation |
temperature_amin is highly correlated with temperature_amax and 3 other fields | High correlation |
temperature_mean is highly correlated with temperature_amax and 3 other fields | High correlation |
time_amin is highly correlated with amperestunden and 6 other fields | High correlation |
time_entladen_stark_vorher is highly correlated with amperestunden and 6 other fields | High correlation |
time_entladen_leicht_vorher is highly correlated with amperestunden and 3 other fields | High correlation |
time_laden_stark_vorher is highly correlated with amperestunden and 4 other fields | High correlation |
time_pause_vorher is highly correlated with amperestunden and 5 other fields | High correlation |
time_temp_hoch is highly correlated with temperature_amax and 3 other fields | High correlation |
time_temp_hoch_vorher is highly correlated with temperature_amax and 7 other fields | High correlation |
amperestunden is highly correlated with zyklus_ and 4 other fields | High correlation |
zyklus_ is highly correlated with amperestunden and 2 other fields | High correlation |
temperature_amax is highly correlated with temperature_amin and 1 other fields | High correlation |
temperature_amin is highly correlated with temperature_amax and 1 other fields | High correlation |
temperature_mean is highly correlated with temperature_amax and 1 other fields | High correlation |
time_amin is highly correlated with amperestunden and 5 other fields | High correlation |
time_entladen_stark_vorher is highly correlated with amperestunden and 3 other fields | High correlation |
time_entladen_leicht_vorher is highly correlated with amperestunden and 2 other fields | High correlation |
time_laden_stark_vorher is highly correlated with amperestunden and 3 other fields | High correlation |
time_pause_vorher is highly correlated with time_amin and 2 other fields | High correlation |
time_temp_hoch is highly correlated with time_temp_hoch_vorher | High correlation |
time_temp_hoch_vorher is highly correlated with time_temp_hoch | High correlation |
amperestunden is highly correlated with zyklus_ and 4 other fields | High correlation |
zyklus_ is highly correlated with amperestunden and 3 other fields | High correlation |
temperature_amax is highly correlated with temperature_amin and 2 other fields | High correlation |
temperature_amin is highly correlated with temperature_amax and 2 other fields | High correlation |
temperature_mean is highly correlated with temperature_amax and 2 other fields | High correlation |
time_amin is highly correlated with amperestunden and 4 other fields | High correlation |
time_entladen_stark_vorher is highly correlated with amperestunden and 4 other fields | High correlation |
time_entladen_leicht_vorher is highly correlated with amperestunden and 2 other fields | High correlation |
time_laden_stark_vorher is highly correlated with amperestunden and 3 other fields | High correlation |
time_pause_vorher is highly correlated with time_amin and 1 other fields | High correlation |
time_temp_hoch is highly correlated with temperature_amax and 2 other fields | High correlation |
amperestunden is highly correlated with zyklus_ and 6 other fields | High correlation |
zyklus_ is highly correlated with amperestunden and 7 other fields | High correlation |
temperature_amax is highly correlated with temperature_amin and 1 other fields | High correlation |
temperature_amin is highly correlated with temperature_amax and 2 other fields | High correlation |
temperature_mean is highly correlated with temperature_amax and 1 other fields | High correlation |
time_amin is highly correlated with amperestunden and 7 other fields | High correlation |
time_entladen_stark_vorher is highly correlated with amperestunden and 7 other fields | High correlation |
time_entladen_leicht_vorher is highly correlated with amperestunden and 7 other fields | High correlation |
time_laden_stark_vorher is highly correlated with amperestunden and 6 other fields | High correlation |
time_pause_vorher is highly correlated with zyklus_ and 5 other fields | High correlation |
time_temp_hoch is highly correlated with amperestunden and 5 other fields | High correlation |
time_temp_hoch_vorher is highly correlated with amperestunden and 8 other fields | High correlation |
time_amin has unique values | Unique |
time_entladen_leicht_vorher has unique values | Unique |
time_laden_stark_vorher has unique values | Unique |
time_entladen_stark_vorher has 40 (4.2%) zeros | Zeros |
time_pause_vorher has 22 (2.3%) zeros | Zeros |
time_temp_hoch has 593 (62.4%) zeros | Zeros |
time_temp_hoch_vorher has 33 (3.5%) zeros | Zeros |
Reproduction
| Analysis started | 2021-12-23 13:33:08.851870 |
|---|---|
| Analysis finished | 2021-12-23 13:33:32.809435 |
| Duration | 23.96 seconds |
| Software version | pandas-profiling v3.1.0 |
| Download configuration | config.json |
| Distinct | 948 |
|---|---|
| Distinct (%) | 99.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.5014888 |
| Minimum | 0 |
|---|---|
| Maximum | 2.147192722 |
| Zeros | 3 |
| Zeros (%) | 0.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 7.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1.011283349 |
| Q1 | 1.253411514 |
| median | 1.491576156 |
| Q3 | 1.754460949 |
| 95-th percentile | 2.043836863 |
| Maximum | 2.147192722 |
| Range | 2.147192722 |
| Interquartile range (IQR) | 0.5010494347 |
Descriptive statistics
| Standard deviation | 0.3325745011 |
|---|---|
| Coefficient of variation (CV) | 0.2214964914 |
| Kurtosis | 0.2232667832 |
| Mean | 1.5014888 |
| Median Absolute Deviation (MAD) | 0.2526541546 |
| Skewness | -0.2003476861 |
| Sum | 1426.41436 |
| Variance | 0.1106057988 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 3 | 0.3% |
| 1.781939909 | 1 | 0.1% |
| 1.746756154 | 1 | 0.1% |
| 2.008983757 | 1 | 0.1% |
| 2.002933988 | 1 | 0.1% |
| 1.943405937 | 1 | 0.1% |
| 1.94311155 | 1 | 0.1% |
| 1.863253171 | 1 | 0.1% |
| 1.86467005 | 1 | 0.1% |
| 1.801244912 | 1 | 0.1% |
| Other values (938) | 938 |
| Value | Count | Frequency (%) |
| 0 | 3 | |
| 0.6929784044 | 1 | 0.1% |
| 0.7487782114 | 1 | 0.1% |
| 0.750202993 | 1 | 0.1% |
| 0.758739532 | 1 | 0.1% |
| 0.7597755255 | 1 | 0.1% |
| 0.7783643746 | 1 | 0.1% |
| 0.7849392036 | 1 | 0.1% |
| 0.8116476265 | 1 | 0.1% |
| 0.8168337649 | 1 | 0.1% |
| Value | Count | Frequency (%) |
| 2.147192722 | 1 | |
| 2.141582404 | 1 | |
| 2.138831784 | 1 | |
| 2.137437355 | 1 | |
| 2.136908838 | 1 | |
| 2.134823039 | 1 | |
| 2.134648283 | 1 | |
| 2.133916152 | 1 | |
| 2.132614816 | 1 | |
| 2.131995793 | 1 |
| Distinct | 861 |
|---|---|
| Distinct (%) | 90.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 28218.97053 |
| Minimum | 1 |
|---|---|
| Maximum | 113576 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 7.5 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 865.8 |
| Q1 | 7952.75 |
| median | 16073 |
| Q3 | 39511.25 |
| 95-th percentile | 93463.65 |
| Maximum | 113576 |
| Range | 113575 |
| Interquartile range (IQR) | 31558.5 |
Descriptive statistics
| Standard deviation | 28321.90788 |
|---|---|
| Coefficient of variation (CV) | 1.003647807 |
| Kurtosis | 0.8231802114 |
| Mean | 28218.97053 |
| Median Absolute Deviation (MAD) | 11970.5 |
| Skewness | 1.327962722 |
| Sum | 26808022 |
| Variance | 802130466 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2 | 19 | 2.0% |
| 3 | 8 | 0.8% |
| 5 | 5 | 0.5% |
| 1 | 4 | 0.4% |
| 24209 | 4 | 0.4% |
| 3031 | 4 | 0.4% |
| 3033 | 4 | 0.4% |
| 6057 | 4 | 0.4% |
| 9087 | 4 | 0.4% |
| 12111 | 4 | 0.4% |
| Other values (851) | 890 |
| Value | Count | Frequency (%) |
| 1 | 4 | 0.4% |
| 2 | 19 | |
| 3 | 8 | |
| 4 | 3 | 0.3% |
| 5 | 5 | 0.5% |
| 9 | 1 | 0.1% |
| 40 | 1 | 0.1% |
| 47 | 2 | 0.2% |
| 854 | 1 | 0.1% |
| 856 | 1 | 0.1% |
| Value | Count | Frequency (%) |
| 113576 | 1 | |
| 113572 | 1 | |
| 110817 | 1 | |
| 110555 | 1 | |
| 110551 | 1 | |
| 109387 | 1 | |
| 109199 | 1 | |
| 109195 | 1 | |
| 107800 | 1 | |
| 107796 | 1 |
temperature_amax
Real number (ℝ)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATION| Distinct | 810 |
|---|---|
| Distinct (%) | 85.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -343.1336119 |
| Minimum | -4099.44775 |
|---|---|
| Maximum | 44.93351 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 90 |
| Negative (%) | 9.5% |
| Memory size | 7.5 KiB |
Quantile statistics
| Minimum | -4099.44775 |
|---|---|
| 5-th percentile | -4093.927 |
| Q1 | 24.64716 |
| median | 27.059845 |
| Q3 | 34.33386 |
| 95-th percentile | 43.01202 |
| Maximum | 44.93351 |
| Range | 4144.38126 |
| Interquartile range (IQR) | 9.6867 |
Descriptive statistics
| Standard deviation | 1183.820648 |
|---|---|
| Coefficient of variation (CV) | -3.450028231 |
| Kurtosis | 6.184014818 |
| Mean | -343.1336119 |
| Median Absolute Deviation (MAD) | 3.35148 |
| Skewness | -2.858384352 |
| Sum | -325976.9313 |
| Variance | 1401431.326 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| -4093.927 | 48 | 5.1% |
| -4094.09814 | 34 | 3.6% |
| 24.43581 | 4 | 0.4% |
| 24.33748 | 3 | 0.3% |
| 24.46182 | 3 | 0.3% |
| 23.67316 | 3 | 0.3% |
| 24.2646 | 3 | 0.3% |
| 27.25782 | 3 | 0.3% |
| 23.31518 | 3 | 0.3% |
| 43.09319 | 2 | 0.2% |
| Other values (800) | 844 |
| Value | Count | Frequency (%) |
| -4099.44775 | 2 | 0.2% |
| -4094.09814 | 34 | |
| -4093.927 | 48 | |
| -4059.5376 | 2 | 0.2% |
| -70.1011 | 1 | 0.1% |
| -63.09559 | 1 | 0.1% |
| -57.93151 | 1 | 0.1% |
| -54.88553 | 1 | 0.1% |
| 22.08074 | 1 | 0.1% |
| 22.64744 | 1 | 0.1% |
| Value | Count | Frequency (%) |
| 44.93351 | 1 | |
| 44.77131 | 1 | |
| 44.75011 | 1 | |
| 44.66674 | 1 | |
| 44.43338 | 1 | |
| 44.32677 | 1 | |
| 44.27815 | 1 | |
| 44.09966 | 1 | |
| 44.0831 | 1 | |
| 44.07764 | 1 |
temperature_amin
Real number (ℝ)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATION| Distinct | 807 |
|---|---|
| Distinct (%) | 84.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -369.2755797 |
| Minimum | -4099.44775 |
|---|---|
| Maximum | 40.65417 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 91 |
| Negative (%) | 9.6% |
| Memory size | 7.5 KiB |
Quantile statistics
| Minimum | -4099.44775 |
|---|---|
| 5-th percentile | -4093.927 |
| Q1 | 19.4810675 |
| median | 21.80882 |
| Q3 | 28.5679825 |
| 95-th percentile | 38.9023835 |
| Maximum | 40.65417 |
| Range | 4140.10192 |
| Interquartile range (IQR) | 9.086915 |
Descriptive statistics
| Standard deviation | 1212.788638 |
|---|---|
| Coefficient of variation (CV) | -3.284237314 |
| Kurtosis | 5.580768786 |
| Mean | -369.2755797 |
| Median Absolute Deviation (MAD) | 3.336185 |
| Skewness | -2.751126451 |
| Sum | -350811.8007 |
| Variance | 1470856.28 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| -4093.927 | 52 | 5.5% |
| -4094.09814 | 34 | 3.6% |
| -4099.44775 | 3 | 0.3% |
| 28.66285 | 3 | 0.3% |
| 21.06748 | 3 | 0.3% |
| 19.5299 | 3 | 0.3% |
| 20.98965 | 3 | 0.3% |
| 19.71828 | 3 | 0.3% |
| 19.16685 | 3 | 0.3% |
| 19.02537 | 2 | 0.2% |
| Other values (797) | 841 |
| Value | Count | Frequency (%) |
| -4099.44775 | 3 | 0.3% |
| -4094.09814 | 34 | |
| -4093.927 | 52 | |
| -4059.5376 | 2 | 0.2% |
| 16.49812 | 1 | 0.1% |
| 17.1661 | 1 | 0.1% |
| 17.38354 | 1 | 0.1% |
| 17.5044 | 1 | 0.1% |
| 17.53201 | 1 | 0.1% |
| 17.55559 | 1 | 0.1% |
| Value | Count | Frequency (%) |
| 40.65417 | 1 | |
| 40.64124 | 1 | |
| 40.56391 | 1 | |
| 40.56279 | 1 | |
| 40.41031 | 1 | |
| 40.32174 | 1 | |
| 40.24242 | 1 | |
| 40.21308 | 1 | |
| 40.11925 | 1 | |
| 39.8741 | 1 |
temperature_mean
Real number (ℝ)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATION| Distinct | 870 |
|---|---|
| Distinct (%) | 91.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -362.7266643 |
| Minimum | -4099.44775 |
|---|---|
| Maximum | 42.14114416 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 91 |
| Negative (%) | 9.6% |
| Memory size | 7.5 KiB |
Quantile statistics
| Minimum | -4099.44775 |
|---|---|
| 5-th percentile | -4093.927 |
| Q1 | 22.3161411 |
| median | 24.4982451 |
| Q3 | 31.68772172 |
| 95-th percentile | 41.02405727 |
| Maximum | 42.14114416 |
| Range | 4141.588894 |
| Interquartile range (IQR) | 9.371580623 |
Descriptive statistics
| Standard deviation | 1206.597105 |
|---|---|
| Coefficient of variation (CV) | -3.326463765 |
| Kurtosis | 5.690477797 |
| Mean | -362.7266643 |
| Median Absolute Deviation (MAD) | 3.192067399 |
| Skewness | -2.770344446 |
| Sum | -344590.331 |
| Variance | 1455876.574 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| -4093.927 | 39 | 4.1% |
| -4094.09814 | 29 | 3.1% |
| -4093.927 | 9 | 0.9% |
| -4094.09814 | 5 | 0.5% |
| -4059.5376 | 2 | 0.2% |
| -4099.44775 | 2 | 0.2% |
| 23.91183181 | 1 | 0.1% |
| 41.20798725 | 1 | 0.1% |
| 41.01648279 | 1 | 0.1% |
| 41.50360734 | 1 | 0.1% |
| Other values (860) | 860 |
| Value | Count | Frequency (%) |
| -4099.44775 | 2 | 0.2% |
| -4094.09814 | 5 | 0.5% |
| -4094.09814 | 29 | |
| -4093.927 | 9 | 0.9% |
| -4093.927 | 39 | |
| -4086.816011 | 1 | 0.1% |
| -4059.5376 | 2 | 0.2% |
| -4036.99036 | 1 | 0.1% |
| -4004.962801 | 1 | 0.1% |
| -3925.289877 | 1 | 0.1% |
| Value | Count | Frequency (%) |
| 42.14114416 | 1 | |
| 42.11761987 | 1 | |
| 42.0327026 | 1 | |
| 41.91600623 | 1 | |
| 41.82337826 | 1 | |
| 41.81604031 | 1 | |
| 41.80844105 | 1 | |
| 41.75436561 | 1 | |
| 41.73001796 | 1 | |
| 41.69768148 | 1 |
time_amin
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONUNIQUE| Distinct | 950 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6860446.252 |
| Minimum | 1633.73 |
|---|---|
| Maximum | 17577173.69 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 7.5 KiB |
Quantile statistics
| Minimum | 1633.73 |
|---|---|
| 5-th percentile | 444543.7585 |
| Q1 | 3126158.735 |
| median | 6566721.22 |
| Q3 | 10263763.56 |
| 95-th percentile | 14223182.87 |
| Maximum | 17577173.69 |
| Range | 17575539.96 |
| Interquartile range (IQR) | 7137604.822 |
Descriptive statistics
| Standard deviation | 4348495.994 |
|---|---|
| Coefficient of variation (CV) | 0.6338503115 |
| Kurtosis | -0.8259038793 |
| Mean | 6860446.252 |
| Median Absolute Deviation (MAD) | 3508038.04 |
| Skewness | 0.2879996498 |
| Sum | 6517423939 |
| Variance | 1.890941741 × 1013 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 385232.92 | 1 | 0.1% |
| 3171585.87 | 1 | 0.1% |
| 7858868.92 | 1 | 0.1% |
| 208842.46 | 1 | 0.1% |
| 226891.06 | 1 | 0.1% |
| 814826.12 | 1 | 0.1% |
| 832841.17 | 1 | 0.1% |
| 1405694.42 | 1 | 0.1% |
| 1424061.95 | 1 | 0.1% |
| 2006333.65 | 1 | 0.1% |
| Other values (940) | 940 |
| Value | Count | Frequency (%) |
| 1633.73 | 1 | |
| 6294.22 | 1 | |
| 9754.78 | 1 | |
| 9800.31 | 1 | |
| 9800.84 | 1 | |
| 9813.11 | 1 | |
| 9849.62 | 1 | |
| 9966.34 | 1 | |
| 10018.01 | 1 | |
| 10092.75 | 1 |
| Value | Count | Frequency (%) |
| 17577173.69 | 1 | |
| 17485573.05 | 1 | |
| 17470024.95 | 1 | |
| 17298505.87 | 1 | |
| 17085565.63 | 1 | |
| 17083278.63 | 1 | |
| 17054456.08 | 1 | |
| 16966176.51 | 1 | |
| 16941806.02 | 1 | |
| 16873033.81 | 1 |
time_entladen_stark_vorher
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONZEROS| Distinct | 597 |
|---|---|
| Distinct (%) | 62.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 205013.9202 |
| Minimum | 0 |
|---|---|
| Maximum | 593181.15 |
| Zeros | 40 |
| Zeros (%) | 4.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 7.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 22304.7675 |
| Q1 | 123008.6775 |
| median | 203374.52 |
| Q3 | 264311.3625 |
| 95-th percentile | 480312.196 |
| Maximum | 593181.15 |
| Range | 593181.15 |
| Interquartile range (IQR) | 141302.685 |
Descriptive statistics
| Standard deviation | 123505.3834 |
|---|---|
| Coefficient of variation (CV) | 0.602424378 |
| Kurtosis | 0.8246641979 |
| Mean | 205013.9202 |
| Median Absolute Deviation (MAD) | 69319.5 |
| Skewness | 0.7630255465 |
| Sum | 194763224.2 |
| Variance | 1.525357972 × 1010 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 40 | 4.2% |
| 239704.04 | 4 | 0.4% |
| 201767.84 | 2 | 0.2% |
| 45712.61 | 2 | 0.2% |
| 26248.56 | 2 | 0.2% |
| 228812.91 | 2 | 0.2% |
| 226026.61 | 2 | 0.2% |
| 221762.48 | 2 | 0.2% |
| 219154.11 | 2 | 0.2% |
| 214002.42 | 2 | 0.2% |
| Other values (587) | 890 |
| Value | Count | Frequency (%) |
| 0 | 40 | |
| 1441.61 | 1 | 0.1% |
| 1597.06 | 1 | 0.1% |
| 1616.74 | 1 | 0.1% |
| 17749.62 | 2 | 0.2% |
| 19338.98 | 1 | 0.1% |
| 21926.61 | 2 | 0.2% |
| 22766.96 | 2 | 0.2% |
| 23109.02 | 1 | 0.1% |
| 23298.04 | 1 | 0.1% |
| Value | Count | Frequency (%) |
| 593181.15 | 1 | |
| 590747.87 | 1 | |
| 588001.68 | 1 | |
| 584509.3 | 1 | |
| 581060.04 | 1 | |
| 577898.06 | 1 | |
| 574226.15 | 1 | |
| 570478.33 | 1 | |
| 566288.94 | 1 | |
| 562124.13 | 1 |
time_entladen_leicht_vorher
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONUNIQUE| Distinct | 950 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1358084.162 |
| Minimum | 7538.12 |
|---|---|
| Maximum | 4347433.06 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 7.5 KiB |
Quantile statistics
| Minimum | 7538.12 |
|---|---|
| 5-th percentile | 123876.6955 |
| Q1 | 468996.755 |
| median | 1105874.61 |
| Q3 | 1896081.998 |
| 95-th percentile | 3784764.458 |
| Maximum | 4347433.06 |
| Range | 4339894.94 |
| Interquartile range (IQR) | 1427085.243 |
Descriptive statistics
| Standard deviation | 1094643.005 |
|---|---|
| Coefficient of variation (CV) | 0.8060200065 |
| Kurtosis | 0.1013639948 |
| Mean | 1358084.162 |
| Median Absolute Deviation (MAD) | 679998.72 |
| Skewness | 0.9663618627 |
| Sum | 1290179954 |
| Variance | 1.198243308 × 1012 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 196178.5 | 1 | 0.1% |
| 714809.15 | 1 | 0.1% |
| 337253.44 | 1 | 0.1% |
| 198416.22 | 1 | 0.1% |
| 205627.7 | 1 | 0.1% |
| 318912.52 | 1 | 0.1% |
| 325908.51 | 1 | 0.1% |
| 420498.37 | 1 | 0.1% |
| 427212.08 | 1 | 0.1% |
| 517643.84 | 1 | 0.1% |
| Other values (940) | 940 |
| Value | Count | Frequency (%) |
| 7538.12 | 1 | |
| 7539.59 | 1 | |
| 7542.95 | 1 | |
| 7552.6 | 1 | |
| 7610.03 | 1 | |
| 7616.33 | 1 | |
| 7629.05 | 1 | |
| 7634.98 | 1 | |
| 7661.04 | 1 | |
| 7665.27 | 1 |
| Value | Count | Frequency (%) |
| 4347433.06 | 1 | |
| 4343519.61 | 1 | |
| 4268724.25 | 1 | |
| 4264733.78 | 1 | |
| 4234224.36 | 1 | |
| 4200003.53 | 1 | |
| 4184108.45 | 1 | |
| 4179980.68 | 1 | |
| 4159345.36 | 1 | |
| 4155906 | 1 |
time_laden_stark_vorher
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONUNIQUE| Distinct | 950 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3649026.058 |
| Minimum | 1627.08 |
|---|---|
| Maximum | 10850409.36 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 7.5 KiB |
Quantile statistics
| Minimum | 1627.08 |
|---|---|
| 5-th percentile | 180774.203 |
| Q1 | 1667120.555 |
| median | 3387895.06 |
| Q3 | 5026416.302 |
| 95-th percentile | 8405080.343 |
| Maximum | 10850409.36 |
| Range | 10848782.28 |
| Interquartile range (IQR) | 3359295.747 |
Descriptive statistics
| Standard deviation | 2470853.712 |
|---|---|
| Coefficient of variation (CV) | 0.6771269025 |
| Kurtosis | -0.3779777288 |
| Mean | 3649026.058 |
| Median Absolute Deviation (MAD) | 1671319.635 |
| Skewness | 0.5570831566 |
| Sum | 3466574755 |
| Variance | 6.105118064 × 1012 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 194718.28 | 1 | 0.1% |
| 2211298.91 | 1 | 0.1% |
| 4734429.79 | 1 | 0.1% |
| 11155.93 | 1 | 0.1% |
| 21971.54 | 1 | 0.1% |
| 444310.17 | 1 | 0.1% |
| 455328.22 | 1 | 0.1% |
| 881343.11 | 1 | 0.1% |
| 893002.1 | 1 | 0.1% |
| 1333416.55 | 1 | 0.1% |
| Other values (940) | 940 |
| Value | Count | Frequency (%) |
| 1627.08 | 1 | |
| 6289.18 | 1 | |
| 9394.74 | 1 | |
| 9440.27 | 1 | |
| 9440.8 | 1 | |
| 9453.07 | 1 | |
| 9489.58 | 1 | |
| 9606.3 | 1 | |
| 9657.97 | 1 | |
| 9732.74 | 1 |
| Value | Count | Frequency (%) |
| 10850409.36 | 1 | |
| 10769780.97 | 1 | |
| 10468424.33 | 1 | |
| 10381041.46 | 1 | |
| 10306316.74 | 1 | |
| 10086358.66 | 1 | |
| 9995981.55 | 1 | |
| 9910653.22 | 1 | |
| 9763684.43 | 1 | |
| 9702559.45 | 1 |
time_pause_vorher
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONZEROS| Distinct | 798 |
|---|---|
| Distinct (%) | 84.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1050077.314 |
| Minimum | 0 |
|---|---|
| Maximum | 5585429.23 |
| Zeros | 22 |
| Zeros (%) | 2.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 7.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 16047.58 |
| Q1 | 129139.4 |
| median | 648877.985 |
| Q3 | 1504034.133 |
| 95-th percentile | 3759876.513 |
| Maximum | 5585429.23 |
| Range | 5585429.23 |
| Interquartile range (IQR) | 1374894.733 |
Descriptive statistics
| Standard deviation | 1183726.529 |
|---|---|
| Coefficient of variation (CV) | 1.127275595 |
| Kurtosis | 2.110042012 |
| Mean | 1050077.314 |
| Median Absolute Deviation (MAD) | 555902.795 |
| Skewness | 1.575044181 |
| Sum | 997573448.2 |
| Variance | 1.401208495 × 1012 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 22 | 2.3% |
| 300 | 16 | 1.7% |
| 14570.71 | 2 | 0.2% |
| 16048.39 | 2 | 0.2% |
| 16047.58 | 2 | 0.2% |
| 28480.9 | 2 | 0.2% |
| 43308.44 | 2 | 0.2% |
| 54539.1 | 2 | 0.2% |
| 68173.6 | 2 | 0.2% |
| 79399.1 | 2 | 0.2% |
| Other values (788) | 896 |
| Value | Count | Frequency (%) |
| 0 | 22 | |
| 300 | 16 | |
| 11400 | 1 | 0.1% |
| 14570.71 | 2 | 0.2% |
| 14574.91 | 2 | 0.2% |
| 15817.74 | 2 | 0.2% |
| 16046.88 | 2 | 0.2% |
| 16047.58 | 2 | 0.2% |
| 16048.39 | 2 | 0.2% |
| 16065.26 | 2 | 0.2% |
| Value | Count | Frequency (%) |
| 5585429.23 | 1 | |
| 5470150.93 | 1 | |
| 5378402.95 | 1 | |
| 5338495.03 | 1 | |
| 5302217.34 | 1 | |
| 5261931.65 | 1 | |
| 5170176.72 | 1 | |
| 5130269.14 | 1 | |
| 5093991.63 | 1 | |
| 5053697.84 | 1 |
time_temp_hoch
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONZEROS| Distinct | 358 |
|---|---|
| Distinct (%) | 37.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1977.097947 |
| Minimum | 0 |
|---|---|
| Maximum | 7730.64 |
| Zeros | 593 |
| Zeros (%) | 62.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 7.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 4522.975 |
| 95-th percentile | 6904.285 |
| Maximum | 7730.64 |
| Range | 7730.64 |
| Interquartile range (IQR) | 4522.975 |
Descriptive statistics
| Standard deviation | 2664.734842 |
|---|---|
| Coefficient of variation (CV) | 1.347801127 |
| Kurtosis | -1.11352209 |
| Mean | 1977.097947 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 0.764488618 |
| Sum | 1878243.05 |
| Variance | 7100811.776 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 593 | |
| 5552.06 | 1 | 0.1% |
| 4684.59 | 1 | 0.1% |
| 4439.53 | 1 | 0.1% |
| 4436.76 | 1 | 0.1% |
| 4376.34 | 1 | 0.1% |
| 4364.01 | 1 | 0.1% |
| 4495.3 | 1 | 0.1% |
| 4513.65 | 1 | 0.1% |
| 4784.88 | 1 | 0.1% |
| Other values (348) | 348 |
| Value | Count | Frequency (%) |
| 0 | 593 | |
| 300 | 1 | 0.1% |
| 2695.9 | 1 | 0.1% |
| 2700.84 | 1 | 0.1% |
| 2731.81 | 1 | 0.1% |
| 2735.55 | 1 | 0.1% |
| 2802.39 | 1 | 0.1% |
| 2826.01 | 1 | 0.1% |
| 2940.84 | 1 | 0.1% |
| 2967.32 | 1 | 0.1% |
| Value | Count | Frequency (%) |
| 7730.64 | 1 | |
| 7710.56 | 1 | |
| 7700.66 | 1 | |
| 7695.55 | 1 | |
| 7693.17 | 1 | |
| 7685.78 | 1 | |
| 7685.27 | 1 | |
| 7683.2 | 1 | |
| 7678.22 | 1 | |
| 7661.04 | 1 |
| Distinct | 638 |
|---|---|
| Distinct (%) | 67.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2680278.352 |
| Minimum | 0 |
|---|---|
| Maximum | 11409748.64 |
| Zeros | 33 |
| Zeros (%) | 3.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 7.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 139765.7 |
| Q1 | 793201.45 |
| median | 1767303.76 |
| Q3 | 3737098.882 |
| 95-th percentile | 8027307.819 |
| Maximum | 11409748.64 |
| Range | 11409748.64 |
| Interquartile range (IQR) | 2943897.432 |
Descriptive statistics
| Standard deviation | 2439237.488 |
|---|---|
| Coefficient of variation (CV) | 0.9100687197 |
| Kurtosis | 0.7340155128 |
| Mean | 2680278.352 |
| Median Absolute Deviation (MAD) | 1314359.26 |
| Skewness | 1.205400973 |
| Sum | 2546264435 |
| Variance | 5.949879525 × 1012 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1578427.2 | 34 | 3.6% |
| 0 | 33 | 3.5% |
| 3739006.82 | 14 | 1.5% |
| 1341971.38 | 12 | 1.3% |
| 3393493.85 | 10 | 1.1% |
| 1497579.63 | 10 | 1.1% |
| 3038733.01 | 9 | 0.9% |
| 1469602.17 | 9 | 0.9% |
| 405011.46 | 8 | 0.8% |
| 405611.66 | 8 | 0.8% |
| Other values (628) | 803 |
| Value | Count | Frequency (%) |
| 0 | 33 | |
| 17395.4 | 1 | 0.1% |
| 17591.57 | 1 | 0.1% |
| 17757.17 | 1 | 0.1% |
| 17797.63 | 1 | 0.1% |
| 18462.93 | 1 | 0.1% |
| 18506.4 | 1 | 0.1% |
| 18585.12 | 1 | 0.1% |
| 21609.26 | 1 | 0.1% |
| 35609.14 | 1 | 0.1% |
| Value | Count | Frequency (%) |
| 11409748.64 | 1 | |
| 10922820.59 | 1 | |
| 10890510.41 | 1 | |
| 10377187.11 | 1 | |
| 10346045.08 | 1 | |
| 10219232.41 | 1 | |
| 10186149.51 | 1 | |
| 9830754.11 | 1 | |
| 9798870.25 | 1 | |
| 9651188.08 | 1 |
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.First rows
| amperestunden | zyklus_ | temperature_amax | temperature_amin | temperature_mean | time_amin | time_entladen_stark_vorher | time_entladen_leicht_vorher | time_laden_stark_vorher | time_pause_vorher | time_temp_hoch | time_temp_hoch_vorher | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2.000364 | 3 | 23.56742 | 18.39025 | 21.798768 | 385232.92 | 0.00 | 196178.50 | 194718.28 | 0.00 | 0.0 | 0.00 |
| 1 | 2.000250 | 5 | 24.06639 | 18.15403 | 21.449898 | 405533.19 | 0.00 | 203379.98 | 207816.73 | 0.00 | 0.0 | 0.00 |
| 2 | 1.958481 | 1009 | 22.81896 | 17.57133 | 20.530506 | 839519.21 | 17749.62 | 312669.57 | 472156.60 | 16048.39 | 0.0 | 178418.56 |
| 3 | 1.963192 | 1011 | 23.64538 | 18.12253 | 21.420698 | 858525.62 | 17749.62 | 319737.63 | 484111.86 | 16048.39 | 0.0 | 178418.56 |
| 4 | 1.911217 | 1925 | 23.89487 | 17.66582 | 20.839432 | 1248403.47 | 36155.14 | 406768.88 | 743215.33 | 28472.48 | 0.0 | 344313.14 |
| 5 | 1.915461 | 1927 | 23.34912 | 17.55559 | 20.933973 | 1267739.95 | 36155.14 | 413665.08 | 755670.79 | 28472.48 | 0.0 | 344313.14 |
| 6 | 1.869892 | 2829 | 23.64538 | 18.24852 | 21.355658 | 1655925.81 | 53512.10 | 507852.99 | 991901.35 | 43291.22 | 0.0 | 508390.77 |
| 7 | 1.866606 | 2831 | 22.64744 | 17.85481 | 20.966977 | 1675254.47 | 53512.10 | 514573.53 | 1004497.97 | 43291.22 | 0.0 | 508390.77 |
| 8 | 1.826606 | 3781 | 23.31793 | 18.40600 | 21.018691 | 2135722.57 | 71716.23 | 607684.52 | 1325711.87 | 55716.52 | 0.0 | 716060.80 |
| 9 | 1.832734 | 3783 | 23.61420 | 18.92570 | 21.702610 | 2154750.80 | 71716.23 | 614282.98 | 1338163.60 | 55716.52 | 0.0 | 716060.80 |
Last rows
| amperestunden | zyklus_ | temperature_amax | temperature_amin | temperature_mean | time_amin | time_entladen_stark_vorher | time_entladen_leicht_vorher | time_laden_stark_vorher | time_pause_vorher | time_temp_hoch | time_temp_hoch_vorher | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 940 | 0.885836 | 101500 | 39.52802 | 35.21501 | 37.680454 | 11671142.74 | 311966.09 | 3883905.64 | 4709299.38 | 964202.21 | 3189.26 | 8.559283e+06 |
| 941 | 0.859189 | 101504 | 37.59567 | 32.32421 | 35.291661 | 11699932.70 | 311966.09 | 3886998.99 | 4727400.08 | 971702.21 | 3093.35 | 8.587977e+06 |
| 942 | 0.824189 | 104515 | 37.68842 | 32.20054 | 35.518379 | 11926129.42 | 314060.12 | 3952264.57 | 4823001.00 | 994867.83 | 2967.32 | 8.775022e+06 |
| 943 | 0.837322 | 104519 | 38.24494 | 32.69522 | 35.364958 | 11956170.18 | 314060.12 | 3955279.04 | 4842574.44 | 1002367.83 | 3014.47 | 8.805110e+06 |
| 944 | 0.778364 | 107536 | 37.70388 | 31.81407 | 35.174338 | 12177284.66 | 315859.21 | 4018987.09 | 4929998.11 | 1029183.27 | 2802.39 | 8.985943e+06 |
| 945 | 0.784939 | 107540 | 37.88939 | 31.96866 | 35.245658 | 12207354.10 | 315859.21 | 4021813.10 | 4949765.16 | 1036683.27 | 2826.01 | 9.016036e+06 |
| 946 | 0.759776 | 110551 | 37.79663 | 32.10779 | 35.343405 | 12427168.28 | 317601.49 | 4080113.57 | 5040620.52 | 1059934.58 | 2735.55 | 9.190943e+06 |
| 947 | 0.758740 | 110555 | 37.53384 | 31.59765 | 34.768506 | 12457189.16 | 317601.49 | 4082845.38 | 5060405.85 | 1067434.58 | 2731.81 | 9.220960e+06 |
| 948 | 0.748778 | 113572 | 38.29132 | 32.40151 | 35.719393 | 12672750.22 | 319549.85 | 4142731.52 | 5144349.95 | 1094276.63 | 2695.90 | 9.394390e+06 |
| 949 | 0.750203 | 113576 | 38.86329 | 32.46334 | 35.958514 | 12703478.83 | 319549.85 | 4145432.36 | 5164882.66 | 1101776.63 | 2700.84 | 9.425124e+06 |